/*
MySQL Data Transfer
Source Host: localhost
Source Database: denn
Target Host: localhost
Target Database: denn
Date: 4/30/2014 12:00:32 PM
*/

-- ----------------------------
-- Table structure for diasvence
-- ----------------------------
CREATE TABLE `diasvence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `diasvence` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for objetivoforaneo
-- ----------------------------
CREATE TABLE `objetivoforaneo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oficio` varchar(32) DEFAULT NULL,
  `rj` varchar(32) DEFAULT NULL,
  `fechasolict` date DEFAULT NULL,
  `fechainicio` date DEFAULT NULL,
  `fechavenc` date DEFAULT NULL,
  `objetivo` varchar(64) DEFAULT NULL,
  `solicitadopor` varchar(64) DEFAULT NULL,
  `nombrecaso` varchar(128) DEFAULT NULL,
  `fiscal` varchar(128) DEFAULT NULL,
  `tipificacion` varchar(128) DEFAULT NULL,
  `operadora` varchar(32) DEFAULT NULL,
  `nombreuser` varchar(32) DEFAULT NULL,
  `apellidouser` varchar(32) DEFAULT NULL,
  `fechasist` date DEFAULT NULL,
  `maquina` varchar(64) DEFAULT NULL,
  `ip` varchar(16) DEFAULT NULL,
  `diasvence` int(11) DEFAULT NULL,
  `nota` varchar(1024) DEFAULT NULL,
  `direccion` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for operadoratel
-- ----------------------------
CREATE TABLE `operadoratel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `diasvence` VALUES ('1', '5');
INSERT INTO `objetivoforaneo` VALUES ('1', 'WQERW', 'EWRE', '2014-04-10', '2014-04-10', '2014-05-10', '(829) 497-4972', 'DSA FA', 'SADFSDF', 'ASDFSDA', 'ASDFDF', 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('2', 'AS D', 'SDFSDF', '2014-04-10', '2014-04-10', '2014-05-10', '(809) 497-4972', 'SAAGD', null, null, null, 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('3', 'SFSA', 'SAASD F', '2014-04-10', '2014-04-10', '2014-05-10', '(849) 325-3413', 'SFSDFADSF', 'SDFDSF', 'FDSDF', 'AFSFD', 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('4', 'FDADS', 'SDFDSF', '2014-04-05', '2014-04-05', '2014-05-05', '(809) 232-3242', 'SADF AS', 'SDFSDF', 'SFSDF', 'SDAFAF', 'CLARO', null, null, null, null, null, '5', null, 'DINTEL');
INSERT INTO `objetivoforaneo` VALUES ('5', 'DS VSDF ', 'SAAGOE R', '2014-04-05', '2014-04-05', '2014-05-05', '(809) 234-6435', 'BVF NDF H', 'FDSGSDG', 'JTGHFGH', 'GHFET', 'VIVA', null, null, null, null, null, '5', null, 'DICRIM');
INSERT INTO `objetivoforaneo` VALUES ('6', 'ASH FHDFG', 'FGHDFG', '2014-04-05', '2014-04-05', '2014-05-05', '(829) 547-6745', 'SAAWER', 'GFHGDH', 'GFHGFH', 'GFHGFD  GHDFH', 'VIVA', null, null, null, null, null, '5', null, 'DICRIM');
INSERT INTO `objetivoforaneo` VALUES ('7', 'FFDGGF', 'DFFDGFD', '2014-04-03', '2014-04-03', '2014-05-03', '(829) 436-4564', 'SDADSFA', 'SDFSD', 'SDAFSD', 'DSFA', 'ORANGE', null, null, null, null, null, '5', null, 'DICRIM');
INSERT INTO `objetivoforaneo` VALUES ('8', 'SD', 'SAAWPOR U', '2014-04-02', '2014-04-02', '2014-05-02', '(829) 497-4975', 'SDF', 'SD', 'SADF', 'SAF', 'ORANGE', null, null, null, null, null, '0', null, 'DICAI');
INSERT INTO `objetivoforaneo` VALUES ('9', 'asSDFLJ', 'HRTRAS', '2014-04-03', '2014-04-03', '2014-05-03', '(809) 324-2342', 'SDRDG', 'FDGGF', 'SDFDS', 'SDF', 'CLARO', null, null, null, null, null, '5', null, 'DICAI');
INSERT INTO `objetivoforaneo` VALUES ('10', 'HGJGFJ', 'GH FGHas', '2014-04-05', '2014-04-05', '2014-05-05', '(809) 213-4234', 'SDFSDF', 'SDFSDFSD', 'SDFSDF', 'AFDS', 'ORANGE', null, null, null, null, null, '5', null, 'DICAN');
INSERT INTO `objetivoforaneo` VALUES ('11', 'DSADF', 'SDAFSDF', '2014-04-27', '2014-04-27', '2014-05-05', '(849) 342-4234', 'DSFASDF', 'SFASD', 'DSFAD', 'AFSSD', 'TRICOM', 'angelbrito31', 'angelbrito31', '2014-04-27', null, null, '5', null, 'DICAN');
INSERT INTO `objetivoforaneo` VALUES ('12', 'sadf', 'SAASA J;', '2014-04-29', '2014-04-29', '2014-04-29', '(809) 664-6446', 'SAASDLA', 'ld jsa', 'd;lsfj ', ';adlfj', 'CLARO', null, null, '2014-04-29', null, null, '5', 'sadfsd', 'DICAN');
INSERT INTO `operadoratel` VALUES ('1', 'CLARO');
INSERT INTO `operadoratel` VALUES ('2', 'ORANGE');
INSERT INTO `operadoratel` VALUES ('3', 'VIVA');
INSERT INTO `operadoratel` VALUES ('4', 'TRICOM');
